/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1408

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 43 41 53 |CHILD IN|SERT CAS|
|00000010| 43 41 44 45 00 20 20 20 | 20 2d 2d 20 45 52 77 69 |CADE.   | -- ERwi|
|00000020| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00000030| 69 6d 65 0d 0a 20 20 20 | 20 2d 2d 20 25 50 61 72 |ime..   | -- %Par|
|00000040| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000050| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00000060| 49 4e 53 45 52 54 20 43 | 41 53 43 41 44 45 20 0d |INSERT C|ASCADE .|
|00000070| 0a 20 20 20 20 28 69 6e | 73 65 72 74 20 69 6e 74 |.    (in|sert int|
|00000080| 6f 20 25 50 61 72 65 6e | 74 20 28 25 50 61 72 65 |o %Paren|t (%Pare|
|00000090| 6e 74 50 4b 28 22 2c 22 | 2c 29 29 0d 0a 20 20 20 |ntPK(","|,))..   |
|000000a0| 20 20 20 73 65 6c 65 63 | 74 20 25 43 68 69 6c 64 |   selec|t %Child|
|000000b0| 46 4b 28 22 2c 22 2c 29 | 0d 0a 20 20 20 20 20 20 |FK(",",)|..      |
|000000c0| 20 20 66 72 6f 6d 20 25 | 43 68 69 6c 64 0d 0a 20 |  from %|Child.. |
|000000d0| 20 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 20 20 |       w|here..  |
|000000e0| 20 20 20 20 20 20 20 20 | 2d 2d 20 25 25 4e 6f 74 |        |-- %%Not|
|000000f0| 6e 75 6c 6c 46 4b 28 25 | 43 68 69 6c 64 2c 22 20 |nullFK(%|Child," |
|00000100| 69 73 20 6e 6f 74 20 6e | 75 6c 6c 20 61 6e 64 22 |is not n|ull and"|
|00000110| 29 20 0d 0a 20 20 20 20 | 20 20 20 20 20 20 25 4e |) ..    |      %N|
|00000120| 6f 74 6e 75 6c 6c 46 4b | 28 25 43 68 69 6c 64 2c |otnullFK|(%Child,|
|00000130| 22 20 69 73 20 6e 6f 74 | 20 6e 75 6c 6c 20 61 6e |" is not| null an|
|00000140| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 20 20 6e |d")..   |       n|
|00000150| 6f 74 20 65 78 69 73 74 | 73 20 28 0d 0a 20 20 20 |ot exist|s (..   |
|00000160| 20 20 20 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 |        | select |
|00000170| 2a 20 66 72 6f 6d 20 25 | 50 61 72 65 6e 74 0d 0a |* from %|Parent..|
|00000180| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 77 68 |        |      wh|
|00000190| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ere..   |        |
|000001a0| 20 20 20 20 20 2d 2d 20 | 25 25 4a 6f 69 6e 46 4b |     -- |%%JoinFK|
|000001b0| 50 4b 28 25 43 68 69 6c | 64 2c 25 50 61 72 65 6e |PK(%Chil|d,%Paren|
|000001c0| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |t," = ",|" and") |
|000001d0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |..      |        |
|000001e0| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 |  %JoinF|KPK(%Chi|
|000001f0| 6c 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ld,%Pare|nt," = "|
|00000200| 2c 22 20 61 6e 64 22 29 | 0d 0a 20 20 20 20 20 20 |," and")|..      |
|00000210| 20 20 20 20 29 0d 0a 20 | 20 20 20 29 20 66 6f 72 |    ).. |   ) for|
|00000220| 20 65 61 63 68 20 72 6f | 77 0d 0a 00 19 27       | each ro|w....'  |
+--------+-------------------------+-------------------------+--------+--------+